Hệ thống xếp lịch học tín chỉ cho sinh viên CNTT trên PHP & MySQL
112.034 lượt xem;
1 -- phpMyAdmin SQL Dump
2 -- version 4.3.11
3 -- http://www.phpmyadmin.net
4 --
5 -- Host: 127.0.0.1
6 -- Generation Time: Jun 02, 2019 at 03:55 AM
7 -- Server version: 5.6.24
8 -- PHP Version: 5.6.8
9
10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11 SET time_zone = "+00:00";
12
13
14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17 /*!40101 SET NAMES utf8 */;
18
19 --
20 -- Database: `qlthoikhoabieu`
21 --
22
23 -- --------------------------------------------------------
24
25 --
26 -- Table structure for table `class_time_table`
27 --
28
29 CREATE TABLE IF NOT EXISTS `class_time_table` (
30 `id` int(10) unsigned NOT NULL,
31 `day` varchar(40) NOT NULL,
32 `time_start` time NOT NULL,
33 `unit_code` varchar(40) NOT NULL,
34 `venue` varchar(40) NOT NULL,
35 `school` int(10) unsigned NOT NULL,
36 `department` int(10) unsigned NOT NULL,
37 `year_of_study` varchar(40) NOT NULL,
38 `time_end` time NOT NULL
39 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
40
41 --
42 -- Dumping data for table `class_time_table`
43 --
44
45 INSERT INTO `class_time_table` (`id`, `day`, `time_start`, `unit_code`, `venue`, `school`, `department`, `year_of_study`, `time_end`) VALUES
46 (1, 'Monday', '08:00:00', 'COM 205', 'L8', 1, 1, '2', '10:00:00'),
47 (2, 'Monday', '11:00:00', 'MAT 205', 'L10', 1, 1, '2', '13:00:00'),
48 (3, 'Tuesday', '08:00:00', 'COM 310', 'NS5', 2, 2, '3', '10:00:00'),
49 (4, 'Tuesday', '16:00:00', 'EDF 210', 'L13', 1, 1, '2', '18:00:00'),
50 (5, 'Sunday', '23:55:00', 'TH10', 'C8', 1, 6, '2', '01:00:00');
51
52 -- --------------------------------------------------------
53
54 --
55 -- Table structure for table `departments`
56 --
57
58 CREATE TABLE IF NOT EXISTS `departments` (
59 `id` int(10) unsigned NOT NULL,
60 `name` varchar(40) NOT NULL,
61 `school` int(10) unsigned NOT NULL
62 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
63
64 --
65 -- Dumping data for table `departments`
66 --
67
68 INSERT INTO `departments` (`id`, `name`, `school`) VALUES
69 (1, 'Kiểm thư phần mềm', 1),
70 (2, 'Mạng máy tính', 2),
71 (3, 'Bảo mật Thông Tin', 3),
72 (4, 'Thực hành pascal', 4),
73 (5, 'Tiếng Anh chuyên ngành 1', 3),
74 (6, 'Tiếng Anh chuyên ngành 2', 1),
75 (7, 'Giáo dục thể chất 1', 2),
76 (8, 'Giáo dục quốc phòng', 3),
77 (9, 'Quản lý kho', 3);
78
79 -- --------------------------------------------------------
80
81 --
82 -- Table structure for table `exam_time_table`
83 --
84
85 CREATE TABLE IF NOT EXISTS `exam_time_table` (
86 `id` int(10) unsigned NOT NULL,
87 `date` date NOT NULL,
88 `time_start` time NOT NULL,
89 `unit_code` varchar(40) NOT NULL,
90 `venue` varchar(40) NOT NULL,
91 `school` int(10) unsigned NOT NULL,
92 `department` int(10) unsigned NOT NULL,
93 `year_of_study` varchar(40) NOT NULL,
94 `time_end` time NOT NULL
95 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
96
97 --
98 -- Dumping data for table `exam_time_table`
99 --
100
101 INSERT INTO `exam_time_table` (`id`, `date`, `time_start`, `unit_code`, `venue`, `school`, `department`, `year_of_study`, `time_end`) VALUES
102 (1, '2018-12-10', '08:00:00', 'COM 205', 'NS4', 1, 1, '2', '10:00:00'),
103 (2, '2018-12-10', '11:00:00', 'COM315', 'ED10', 2, 2, '3', '13:00:00'),
104 (3, '2019-05-29', '02:00:00', 'TH001', 'Tầng A8', 3, 8, '2', '03:00:00'),
105 (4, '2019-07-29', '08:00:00', 'TQP001', 'CT09', 2, 2, '3', '21:00:00'),
106 (5, '2019-08-29', '03:00:00', 'MS50', 'G9', 3, 3, '1', '04:00:00'),
107 (6, '0000-00-00', '00:00:00', 'K002', 'K50', 2, 2, '1', '12:50:00');
108
109 -- --------------------------------------------------------
110
111 --
112 -- Table structure for table `membership_grouppermissions`
113 --
114
115 CREATE TABLE IF NOT EXISTS `membership_grouppermissions` (
116 `permissionID` int(10) unsigned NOT NULL,
117 `groupID` int(11) DEFAULT NULL,
118 `tableName` varchar(100) DEFAULT NULL,
119 `allowInsert` tinyint(4) DEFAULT NULL,
120 `allowView` tinyint(4) NOT NULL DEFAULT '0',
121 `allowEdit` tinyint(4) NOT NULL DEFAULT '0',
122 `allowDelete` tinyint(4) NOT NULL DEFAULT '0'
123 ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
124
125 --
126 -- Dumping data for table `membership_grouppermissions`
127 --
128
129 INSERT INTO `membership_grouppermissions` (`permissionID`, `groupID`, `tableName`, `allowInsert`, `allowView`, `allowEdit`, `allowDelete`) VALUES
130 (1, 2, 'schools', 1, 3, 3, 3),
131 (2, 2, 'departments', 1, 3, 3, 3),
132 (3, 2, 'class_time_table', 1, 3, 3, 3),
133 (4, 2, 'exam_time_table', 1, 3, 3, 3),
134 (5, 2, 'personal_time_table', 1, 3, 3, 3),
135 (6, 2, 'student_details', 1, 3, 3, 3),
136 (7, 2, 'student_details', 1, 3, 3, 3),
137 (8, 3, 'schools', 0, 0, 0, 0),
138 (9, 3, 'departments', 0, 0, 0, 0),
139 (10, 3, 'class_time_table', 0, 3, 0, 0),
140 (11, 3, 'exam_time_table', 0, 3, 0, 0),
141 (12, 3, 'personal_time_table', 1, 1, 1, 1),
142 (13, 3, 'student_details', 1, 1, 1, 1),
143 (20, 2, 'notices', 1, 3, 3, 3),
144 (21, 4, 'schools', 0, 0, 0, 0),
145 (22, 4, 'departments', 0, 0, 0, 0),
146 (23, 4, 'class_time_table', 1, 1, 1, 1),
147 (24, 4, 'exam_time_table', 1, 1, 1, 1),
148 (25, 4, 'personal_time_table', 0, 0, 0, 0),
149 (26, 4, 'student_details', 0, 0, 0, 0),
150 (27, 4, 'notices', 1, 1, 1, 1),
151 (28, 2, 'Ngành họcs', 1, 3, 3, 3);
152
153 -- --------------------------------------------------------
154
155 --
156 -- Table structure for table `membership_groups`
157 --
158
159 CREATE TABLE IF NOT EXISTS `membership_groups` (
160 `groupID` int(10) unsigned NOT NULL,
161 `name` varchar(20) DEFAULT NULL,
162 `description` text,
163 `allowSignup` tinyint(4) DEFAULT NULL,
164 `needsApproval` tinyint(4) DEFAULT NULL
165 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
166
167 --
168 -- Dumping data for table `membership_groups`
169 --
170
171 INSERT INTO `membership_groups` (`groupID`, `name`, `description`, `allowSignup`, `needsApproval`) VALUES
172 (1, 'anonymous', 'Anonymous group created automatically on 2018-12-04', 0, 0),
173 (2, 'Admins', 'Admin group created automatically on 2018-12-04', 0, 1),
174 (3, 'students', 'all students in this group', 1, 0),
175 (4, 'Class reps', 'all class reps', 0, 1);
176
177 -- --------------------------------------------------------
178
179 --
180 -- Table structure for table `membership_userpermissions`
181 --
182
183 CREATE TABLE IF NOT EXISTS `membership_userpermissions` (
184 `permissionID` int(10) unsigned NOT NULL,
185 `memberID` varchar(20) NOT NULL,
186 `tableName` varchar(100) DEFAULT NULL,
187 `allowInsert` tinyint(4) DEFAULT NULL,
188 `allowView` tinyint(4) NOT NULL DEFAULT '0',
189 `allowEdit` tinyint(4) NOT NULL DEFAULT '0',
190 `allowDelete` tinyint(4) NOT NULL DEFAULT '0'
191 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
192
193 -- --------------------------------------------------------
194
195 --
196 -- Table structure for table `membership_userrecords`
197 --
198
199 CREATE TABLE IF NOT EXISTS `membership_userrecords` (
200 `recID` bigint(20) unsigned NOT NULL,
201 `tableName` varchar(100) DEFAULT NULL,
202 `pkValue` varchar(255) DEFAULT NULL,
203 `memberID` varchar(20) DEFAULT NULL,
204 `dateAdded` bigint(20) unsigned DEFAULT NULL,
205 `dateUpdated` bigint(20) unsigned DEFAULT NULL,
206 `groupID` int(11) DEFAULT NULL
207 ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
208
209 --
210 -- Dumping data for table `membership_userrecords`
211 --
212
213 INSERT INTO `membership_userrecords` (`recID`, `tableName`, `pkValue`, `memberID`, `dateAdded`, `dateUpdated`, `groupID`) VALUES
214 (1, 'schools', '1', 'admin', 1543914528, 1559183176, 2),
215 (2, 'departments', '1', 'admin', 1543914679, 1559183248, 2),
216 (3, 'schools', '2', 'admin', 1543914710, 1559183195, 2),
217 (4, 'departments', '2', 'admin', 1543914732, 1559181325, 2),
218 (5, 'class_time_table', '1', 'admin', 1543914908, 1543915406, 2),
219 (6, 'class_time_table', '2', 'admin', 1543915046, 1543915421, 2),
220 (7, 'class_time_table', '3', 'admin', 1543915081, 1543915435, 2),
221 (8, 'exam_time_table', '1', 'admin', 1543915517, 1543915527, 2),
222 (9, 'exam_time_table', '2', 'admin', 1543915607, 1543915607, 2),
223 (10, 'student_details', '1', 'ronnie', 1543916441, 1559182220, 3),
224 (11, 'notices', '1', 'admin', 1543917355, 1559182429, 2),
225 (12, 'class_time_table', '4', 'koech', 1543929297, 1543929297, 4),
226 (13, 'notices', '2', 'koech', 1543929368, 1559182387, 4),
227 (14, 'personal_time_table', '1', 'ronnie', 1543931609, 1559181973, 3),
228 (15, 'student_details', '2', 'kenny', 1543943132, 1559182329, 3),
229 (16, 'student_details', '3', 'omollo', 1543989167, 1559182308, 3),
230 (17, 'student_details', '4', 'hello', 1544000833, 1559182344, 3),
231 (18, 'notices', '3', 'admin', 1559118512, 1559118512, 2),
232 (19, 'personal_time_table', '2', 'admin', 1559182480, 1559182480, 2),
233 (20, 'schools', '3', 'admin', 1559183209, 1559183209, 2),
234 (21, 'schools', '4', 'admin', 1559183233, 1559183233, 2),
235 (22, 'departments', '3', 'admin', 1559183264, 1559183264, 2),
236 (23, 'departments', '4', 'admin', 1559183279, 1559183279, 2),
237 (24, 'departments', '5', 'admin', 1559183351, 1559183351, 2),
238 (25, 'departments', '6', 'admin', 1559183371, 1559183371, 2),
239 (26, 'departments', '7', 'admin', 1559183383, 1559183383, 2),
240 (27, 'departments', '8', 'admin', 1559183393, 1559183393, 2),
241 (28, 'class_time_table', '5', 'admin', 1559183465, 1559183465, 2),
242 (29, 'exam_time_table', '3', 'admin', 1559183503, 1559183503, 2),
243 (30, 'exam_time_table', '4', 'admin', 1559183553, 1559183553, 2),
244 (31, 'exam_time_table', '5', 'admin', 1559183587, 1559183587, 2),
245 (32, 'departments', '9', 'admin', 1559183674, 1559183674, 2),
246 (33, 'schools', '5', 'admin', 1559183702, 1559183702, 2),
247 (34, 'exam_time_table', '6', 'koech', 1559184316, 1559184316, 4);
248
249 -- --------------------------------------------------------
250
251 --
252 -- Table structure for table `membership_users`
253 --
254
255 CREATE TABLE IF NOT EXISTS `membership_users` (
256 `memberID` varchar(20) NOT NULL,
257 `passMD5` varchar(40) DEFAULT NULL,
258 `email` varchar(100) DEFAULT NULL,
259 `signupDate` date DEFAULT NULL,
260 `groupID` int(10) unsigned DEFAULT NULL,
261 `isBanned` tinyint(4) DEFAULT NULL,
262 `isApproved` tinyint(4) DEFAULT NULL,
263 `custom1` text,
264 `custom2` text,
265 `custom3` text,
266 `custom4` text,
267 `comments` text,
268 `pass_reset_key` varchar(100) DEFAULT NULL,
269 `pass_reset_expiry` int(10) unsigned DEFAULT NULL
270 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
271
272 --
273 -- Dumping data for table `membership_users`
274 --
275
276 INSERT INTO `membership_users` (`memberID`, `passMD5`, `email`, `signupDate`, `groupID`, `isBanned`, `isApproved`, `custom1`, `custom2`, `custom3`, `custom4`, `comments`, `pass_reset_key`, `pass_reset_expiry`) VALUES
277 ('admin', '7488e331b8b64e5794da3fa4eb10ad5d', 'ronniengoda@gmail.com', '2018-12-04', 2, 0, 1, NULL, NULL, NULL, NULL, 'Admin member created automatically on 2018-12-04\nRecord updated automatically on 2018-12-04', NULL, NULL),
278 ('guest', '827ccb0eea8a706c4c34a16891f84e7b', NULL, '2018-12-04', 1, 0, 1, NULL, NULL, NULL, NULL, 'Anonymous member created automatically on 2018-12-04', NULL, NULL),
279 ('hello', '827ccb0eea8a706c4c34a16891f84e7b', 'hello@world.com', '2018-12-05', 3, 0, 1, 'Technology education', '', '', '', 'member signed up through the registration form.', NULL, NULL),
280 ('kenny', '827ccb0eea8a706c4c34a16891f84e7b', 'kenny@gmail.co', '2018-12-04', 3, 0, 1, 'Agtech', '', '', '', 'member signed up through the registration form.', NULL, NULL),
281 ('koech', '827ccb0eea8a706c4c34a16891f84e7b', 'charleskoech@gmail.com', '2018-12-04', 4, 0, 1, 'Technology education', '', '', '', 'Class rep TED 2ND years 2018', NULL, NULL),
282 ('ronnie', '827ccb0eea8a706c4c34a16891f84e7b', 'ronniengoda@gmail.com', '2018-12-04', 3, 0, 1, 'Technology education', '', '', '', 'member signed up through the registration form.', NULL, NULL),
283 ('sinhvien', '827ccb0eea8a706c4c34a16891f84e7b', 'omollo@nimetoka.bondo', '2018-12-05', 3, 0, 1, 'Og', '', '', '', 'member signed up through the registration form.', NULL, NULL);
284
285 -- --------------------------------------------------------
286
287 --
288 -- Table structure for table `ngành họcs`
289 --
290
291 CREATE TABLE IF NOT EXISTS `ngành họcs` (
292 `id` int(10) unsigned NOT NULL,
293 `name` varchar(40) NOT NULL,
294 `school` int(10) unsigned NOT NULL
295 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
296
297 -- --------------------------------------------------------
298
299 --
300 -- Table structure for table `notices`
301 --
302
303 CREATE TABLE IF NOT EXISTS `notices` (
304 `id` int(10) unsigned NOT NULL,
305 `notice` text NOT NULL,
306 `school` int(10) unsigned NOT NULL,
307 `department` int(10) unsigned NOT NULL,
308 `year_of_study` varchar(40) NOT NULL,
309 `date` date DEFAULT NULL
310 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
311
312 --
313 -- Dumping data for table `notices`
314 --
315
316 INSERT INTO `notices` (`id`, `notice`, `school`, `department`, `year_of_study`, `date`) VALUES
317 (1, 'Lớp tổ chức thăm bạn Chinh lằm viền ngày 20/10', 1, 1, '2', '2018-12-04'),
318 (2, 'Lịch lao động lớp kiểm thử phần mềm', 1, 1, '2', '2018-12-04'),
319 (3, 'Hiển thị thông tin lớp học ngày mai, mọi người đi đầy đủ nhé', 1, 1, '3', '2019-05-29');
320
321 -- --------------------------------------------------------
322
323 --
324 -- Table structure for table `personal_time_table`
325 --
326
327 CREATE TABLE IF NOT EXISTS `personal_time_table` (
328 `id` int(10) unsigned NOT NULL,
329 `day` varchar(40) NOT NULL,
330 `time_start` time NOT NULL,
331 `activity` varchar(40) NOT NULL,
332 `time_end` time NOT NULL
333 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
334
335 --
336 -- Dumping data for table `personal_time_table`
337 --
338
339 INSERT INTO `personal_time_table` (`id`, `day`, `time_start`, `activity`, `time_end`) VALUES
340 (1, 'Tuesday', '18:00:00', 'Học lý thuyết', '19:00:00'),
341 (2, 'Monday', '20:00:00', 'Làm bài tập lớn', '10:00:00');
342
343 -- --------------------------------------------------------
344
345 --
346 -- Table structure for table `schools`
347 --
348
349 CREATE TABLE IF NOT EXISTS `schools` (
350 `id` int(10) unsigned NOT NULL,
351 `name` varchar(40) NOT NULL
352 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
353
354 --
355 -- Dumping data for table `schools`
356 --
357
358 INSERT INTO `schools` (`id`, `name`) VALUES
359 (1, 'CNTT K45A'),
360 (2, 'Tin Học Văn Phòng'),
361 (3, 'CNTT K45B'),
362 (4, 'Tin Học 3A'),
363 (5, 'K01');
364
365 -- --------------------------------------------------------
366
367 --
368 -- Table structure for table `student_details`
369 --
370
371 CREATE TABLE IF NOT EXISTS `student_details` (
372 `id` int(10) unsigned NOT NULL,
373 `full_name` varchar(40) NOT NULL,
374 `school` int(10) unsigned NOT NULL,
375 `department` int(10) unsigned NOT NULL,
376 `year_of_study` varchar(40) NOT NULL,
377 `reg_no` varchar(40) NOT NULL
378 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
379
380 --
381 -- Dumping data for table `student_details`
382 --
383
384 INSERT INTO `student_details` (`id`, `full_name`, `school`, `department`, `year_of_study`, `reg_no`) VALUES
385 (1, 'Phạm Quang Sáng', 1, 1, '2', 'TED/118/19'),
386 (2, 'Cao Văn Bằng', 2, 2, '4', 'COM/111/19'),
387 (3, 'Trần Anh Thư', 1, 1, '2', 'TED/1234/19'),
388 (4, 'Lê Hương', 2, 2, '4', 'COM/134/19');
389
390 --
391 -- Indexes for dumped tables
392 --
393
394 --
395 -- Indexes for table `class_time_table`
396 --
397 ALTER TABLE `class_time_table`
398 ADD PRIMARY KEY (`id`), ADD KEY `school` (`school`), ADD KEY `department` (`department`);
399
400 --
401 -- Indexes for table `departments`
402 --
403 ALTER TABLE `departments`
404 ADD PRIMARY KEY (`id`), ADD KEY `school` (`school`);
405
406 --
407 -- Indexes for table `exam_time_table`
408 --
409 ALTER TABLE `exam_time_table`
410 ADD PRIMARY KEY (`id`), ADD KEY `school` (`school`), ADD KEY `department` (`department`);
411
412 --
413 -- Indexes for table `membership_grouppermissions`
414 --
415 ALTER TABLE `membership_grouppermissions`
416 ADD PRIMARY KEY (`permissionID`);
417
418 --
419 -- Indexes for table `membership_groups`
420 --
421 ALTER TABLE `membership_groups`
422 ADD PRIMARY KEY (`groupID`);
423
424 --
425 -- Indexes for table `membership_userpermissions`
426 --
427 ALTER TABLE `membership_userpermissions`
428 ADD PRIMARY KEY (`permissionID`);
429
430 --
431 -- Indexes for table `membership_userrecords`
432 --
433 ALTER TABLE `membership_userrecords`
434 ADD PRIMARY KEY (`recID`), ADD UNIQUE KEY `tableName_pkValue` (`tableName`,`pkValue`), ADD KEY `pkValue` (`pkValue`), ADD KEY `tableName` (`tableName`), ADD KEY `memberID` (`memberID`), ADD KEY `groupID` (`groupID`);
435
436 --
437 -- Indexes for table `membership_users`
438 --
439 ALTER TABLE `membership_users`
440 ADD PRIMARY KEY (`memberID`), ADD KEY `groupID` (`groupID`);
441
442 --
443 -- Indexes for table `ngành họcs`
444 --
445 ALTER TABLE `ngành họcs`
446 ADD PRIMARY KEY (`id`), ADD KEY `school` (`school`);
447
448 --
449 -- Indexes for table `notices`
450 --
451 ALTER TABLE `notices`
452 ADD PRIMARY KEY (`id`), ADD KEY `school` (`school`), ADD KEY `department` (`department`);
453
454 --
455 -- Indexes for table `personal_time_table`
456 --
457 ALTER TABLE `personal_time_table`
458 ADD PRIMARY KEY (`id`);
459
460 --
461 -- Indexes for table `schools`
462 --
463 ALTER TABLE `schools`
464 ADD PRIMARY KEY (`id`);
465
466 --
467 -- Indexes for table `student_details`
468 --
469 ALTER TABLE `student_details`
470 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `reg_no_unique` (`reg_no`), ADD KEY `school` (`school`), ADD KEY `department` (`department`);
471
472 --
473 -- AUTO_INCREMENT for dumped tables
474 --
475
476 --
477 -- AUTO_INCREMENT for table `class_time_table`
478 --
479 ALTER TABLE `class_time_table`
480 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
481 --
482 -- AUTO_INCREMENT for table `departments`
483 --
484 ALTER TABLE `departments`
485 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
486 --
487 -- AUTO_INCREMENT for table `exam_time_table`
488 --
489 ALTER TABLE `exam_time_table`
490 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
491 --
492 -- AUTO_INCREMENT for table `membership_grouppermissions`
493 --
494 ALTER TABLE `membership_grouppermissions`
495 MODIFY `permissionID` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
496 --
497 -- AUTO_INCREMENT for table `membership_groups`
498 --
499 ALTER TABLE `membership_groups`
500 MODIFY `groupID` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
501 --
502 -- AUTO_INCREMENT for table `membership_userpermissions`
503 --
504 ALTER TABLE `membership_userpermissions`
505 MODIFY `permissionID` int(10) unsigned NOT NULL AUTO_INCREMENT;
506 --
507 -- AUTO_INCREMENT for table `membership_userrecords`
508 --
509 ALTER TABLE `membership_userrecords`
510 MODIFY `recID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=35;
511 --
512 -- AUTO_INCREMENT for table `ngành họcs`
513 --
514 ALTER TABLE `ngành họcs`
515 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
516 --
517 -- AUTO_INCREMENT for table `notices`
518 --
519 ALTER TABLE `notices`
520 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
521 --
522 -- AUTO_INCREMENT for table `personal_time_table`
523 --
524 ALTER TABLE `personal_time_table`
525 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
526 --
527 -- AUTO_INCREMENT for table `schools`
528 --
529 ALTER TABLE `schools`
530 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
531 --
532 -- AUTO_INCREMENT for table `student_details`
533 --
534 ALTER TABLE `student_details`
535 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
536 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
537 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
538 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2 -- version 4.3.11
3 -- http://www.phpmyadmin.net
4 --
5 -- Host: 127.0.0.1
6 -- Generation Time: Jun 02, 2019 at 03:55 AM
7 -- Server version: 5.6.24
8 -- PHP Version: 5.6.8
9
10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11 SET time_zone = "+00:00";
12
13
14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17 /*!40101 SET NAMES utf8 */;
18
19 --
20 -- Database: `qlthoikhoabieu`
21 --
22
23 -- --------------------------------------------------------
24
25 --
26 -- Table structure for table `class_time_table`
27 --
28
29 CREATE TABLE IF NOT EXISTS `class_time_table` (
30 `id` int(10) unsigned NOT NULL,
31 `day` varchar(40) NOT NULL,
32 `time_start` time NOT NULL,
33 `unit_code` varchar(40) NOT NULL,
34 `venue` varchar(40) NOT NULL,
35 `school` int(10) unsigned NOT NULL,
36 `department` int(10) unsigned NOT NULL,
37 `year_of_study` varchar(40) NOT NULL,
38 `time_end` time NOT NULL
39 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
40
41 --
42 -- Dumping data for table `class_time_table`
43 --
44
45 INSERT INTO `class_time_table` (`id`, `day`, `time_start`, `unit_code`, `venue`, `school`, `department`, `year_of_study`, `time_end`) VALUES
46 (1, 'Monday', '08:00:00', 'COM 205', 'L8', 1, 1, '2', '10:00:00'),
47 (2, 'Monday', '11:00:00', 'MAT 205', 'L10', 1, 1, '2', '13:00:00'),
48 (3, 'Tuesday', '08:00:00', 'COM 310', 'NS5', 2, 2, '3', '10:00:00'),
49 (4, 'Tuesday', '16:00:00', 'EDF 210', 'L13', 1, 1, '2', '18:00:00'),
50 (5, 'Sunday', '23:55:00', 'TH10', 'C8', 1, 6, '2', '01:00:00');
51
52 -- --------------------------------------------------------
53
54 --
55 -- Table structure for table `departments`
56 --
57
58 CREATE TABLE IF NOT EXISTS `departments` (
59 `id` int(10) unsigned NOT NULL,
60 `name` varchar(40) NOT NULL,
61 `school` int(10) unsigned NOT NULL
62 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
63
64 --
65 -- Dumping data for table `departments`
66 --
67
68 INSERT INTO `departments` (`id`, `name`, `school`) VALUES
69 (1, 'Kiểm thư phần mềm', 1),
70 (2, 'Mạng máy tính', 2),
71 (3, 'Bảo mật Thông Tin', 3),
72 (4, 'Thực hành pascal', 4),
73 (5, 'Tiếng Anh chuyên ngành 1', 3),
74 (6, 'Tiếng Anh chuyên ngành 2', 1),
75 (7, 'Giáo dục thể chất 1', 2),
76 (8, 'Giáo dục quốc phòng', 3),
77 (9, 'Quản lý kho', 3);
78
79 -- --------------------------------------------------------
80
81 --
82 -- Table structure for table `exam_time_table`
83 --
84
85 CREATE TABLE IF NOT EXISTS `exam_time_table` (
86 `id` int(10) unsigned NOT NULL,
87 `date` date NOT NULL,
88 `time_start` time NOT NULL,
89 `unit_code` varchar(40) NOT NULL,
90 `venue` varchar(40) NOT NULL,
91 `school` int(10) unsigned NOT NULL,
92 `department` int(10) unsigned NOT NULL,
93 `year_of_study` varchar(40) NOT NULL,
94 `time_end` time NOT NULL
95 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
96
97 --
98 -- Dumping data for table `exam_time_table`
99 --
100
101 INSERT INTO `exam_time_table` (`id`, `date`, `time_start`, `unit_code`, `venue`, `school`, `department`, `year_of_study`, `time_end`) VALUES
102 (1, '2018-12-10', '08:00:00', 'COM 205', 'NS4', 1, 1, '2', '10:00:00'),
103 (2, '2018-12-10', '11:00:00', 'COM315', 'ED10', 2, 2, '3', '13:00:00'),
104 (3, '2019-05-29', '02:00:00', 'TH001', 'Tầng A8', 3, 8, '2', '03:00:00'),
105 (4, '2019-07-29', '08:00:00', 'TQP001', 'CT09', 2, 2, '3', '21:00:00'),
106 (5, '2019-08-29', '03:00:00', 'MS50', 'G9', 3, 3, '1', '04:00:00'),
107 (6, '0000-00-00', '00:00:00', 'K002', 'K50', 2, 2, '1', '12:50:00');
108
109 -- --------------------------------------------------------
110
111 --
112 -- Table structure for table `membership_grouppermissions`
113 --
114
115 CREATE TABLE IF NOT EXISTS `membership_grouppermissions` (
116 `permissionID` int(10) unsigned NOT NULL,
117 `groupID` int(11) DEFAULT NULL,
118 `tableName` varchar(100) DEFAULT NULL,
119 `allowInsert` tinyint(4) DEFAULT NULL,
120 `allowView` tinyint(4) NOT NULL DEFAULT '0',
121 `allowEdit` tinyint(4) NOT NULL DEFAULT '0',
122 `allowDelete` tinyint(4) NOT NULL DEFAULT '0'
123 ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
124
125 --
126 -- Dumping data for table `membership_grouppermissions`
127 --
128
129 INSERT INTO `membership_grouppermissions` (`permissionID`, `groupID`, `tableName`, `allowInsert`, `allowView`, `allowEdit`, `allowDelete`) VALUES
130 (1, 2, 'schools', 1, 3, 3, 3),
131 (2, 2, 'departments', 1, 3, 3, 3),
132 (3, 2, 'class_time_table', 1, 3, 3, 3),
133 (4, 2, 'exam_time_table', 1, 3, 3, 3),
134 (5, 2, 'personal_time_table', 1, 3, 3, 3),
135 (6, 2, 'student_details', 1, 3, 3, 3),
136 (7, 2, 'student_details', 1, 3, 3, 3),
137 (8, 3, 'schools', 0, 0, 0, 0),
138 (9, 3, 'departments', 0, 0, 0, 0),
139 (10, 3, 'class_time_table', 0, 3, 0, 0),
140 (11, 3, 'exam_time_table', 0, 3, 0, 0),
141 (12, 3, 'personal_time_table', 1, 1, 1, 1),
142 (13, 3, 'student_details', 1, 1, 1, 1),
143 (20, 2, 'notices', 1, 3, 3, 3),
144 (21, 4, 'schools', 0, 0, 0, 0),
145 (22, 4, 'departments', 0, 0, 0, 0),
146 (23, 4, 'class_time_table', 1, 1, 1, 1),
147 (24, 4, 'exam_time_table', 1, 1, 1, 1),
148 (25, 4, 'personal_time_table', 0, 0, 0, 0),
149 (26, 4, 'student_details', 0, 0, 0, 0),
150 (27, 4, 'notices', 1, 1, 1, 1),
151 (28, 2, 'Ngành họcs', 1, 3, 3, 3);
152
153 -- --------------------------------------------------------
154
155 --
156 -- Table structure for table `membership_groups`
157 --
158
159 CREATE TABLE IF NOT EXISTS `membership_groups` (
160 `groupID` int(10) unsigned NOT NULL,
161 `name` varchar(20) DEFAULT NULL,
162 `description` text,
163 `allowSignup` tinyint(4) DEFAULT NULL,
164 `needsApproval` tinyint(4) DEFAULT NULL
165 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
166
167 --
168 -- Dumping data for table `membership_groups`
169 --
170
171 INSERT INTO `membership_groups` (`groupID`, `name`, `description`, `allowSignup`, `needsApproval`) VALUES
172 (1, 'anonymous', 'Anonymous group created automatically on 2018-12-04', 0, 0),
173 (2, 'Admins', 'Admin group created automatically on 2018-12-04', 0, 1),
174 (3, 'students', 'all students in this group', 1, 0),
175 (4, 'Class reps', 'all class reps', 0, 1);
176
177 -- --------------------------------------------------------
178
179 --
180 -- Table structure for table `membership_userpermissions`
181 --
182
183 CREATE TABLE IF NOT EXISTS `membership_userpermissions` (
184 `permissionID` int(10) unsigned NOT NULL,
185 `memberID` varchar(20) NOT NULL,
186 `tableName` varchar(100) DEFAULT NULL,
187 `allowInsert` tinyint(4) DEFAULT NULL,
188 `allowView` tinyint(4) NOT NULL DEFAULT '0',
189 `allowEdit` tinyint(4) NOT NULL DEFAULT '0',
190 `allowDelete` tinyint(4) NOT NULL DEFAULT '0'
191 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
192
193 -- --------------------------------------------------------
194
195 --
196 -- Table structure for table `membership_userrecords`
197 --
198
199 CREATE TABLE IF NOT EXISTS `membership_userrecords` (
200 `recID` bigint(20) unsigned NOT NULL,
201 `tableName` varchar(100) DEFAULT NULL,
202 `pkValue` varchar(255) DEFAULT NULL,
203 `memberID` varchar(20) DEFAULT NULL,
204 `dateAdded` bigint(20) unsigned DEFAULT NULL,
205 `dateUpdated` bigint(20) unsigned DEFAULT NULL,
206 `groupID` int(11) DEFAULT NULL
207 ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
208
209 --
210 -- Dumping data for table `membership_userrecords`
211 --
212
213 INSERT INTO `membership_userrecords` (`recID`, `tableName`, `pkValue`, `memberID`, `dateAdded`, `dateUpdated`, `groupID`) VALUES
214 (1, 'schools', '1', 'admin', 1543914528, 1559183176, 2),
215 (2, 'departments', '1', 'admin', 1543914679, 1559183248, 2),
216 (3, 'schools', '2', 'admin', 1543914710, 1559183195, 2),
217 (4, 'departments', '2', 'admin', 1543914732, 1559181325, 2),
218 (5, 'class_time_table', '1', 'admin', 1543914908, 1543915406, 2),
219 (6, 'class_time_table', '2', 'admin', 1543915046, 1543915421, 2),
220 (7, 'class_time_table', '3', 'admin', 1543915081, 1543915435, 2),
221 (8, 'exam_time_table', '1', 'admin', 1543915517, 1543915527, 2),
222 (9, 'exam_time_table', '2', 'admin', 1543915607, 1543915607, 2),
223 (10, 'student_details', '1', 'ronnie', 1543916441, 1559182220, 3),
224 (11, 'notices', '1', 'admin', 1543917355, 1559182429, 2),
225 (12, 'class_time_table', '4', 'koech', 1543929297, 1543929297, 4),
226 (13, 'notices', '2', 'koech', 1543929368, 1559182387, 4),
227 (14, 'personal_time_table', '1', 'ronnie', 1543931609, 1559181973, 3),
228 (15, 'student_details', '2', 'kenny', 1543943132, 1559182329, 3),
229 (16, 'student_details', '3', 'omollo', 1543989167, 1559182308, 3),
230 (17, 'student_details', '4', 'hello', 1544000833, 1559182344, 3),
231 (18, 'notices', '3', 'admin', 1559118512, 1559118512, 2),
232 (19, 'personal_time_table', '2', 'admin', 1559182480, 1559182480, 2),
233 (20, 'schools', '3', 'admin', 1559183209, 1559183209, 2),
234 (21, 'schools', '4', 'admin', 1559183233, 1559183233, 2),
235 (22, 'departments', '3', 'admin', 1559183264, 1559183264, 2),
236 (23, 'departments', '4', 'admin', 1559183279, 1559183279, 2),
237 (24, 'departments', '5', 'admin', 1559183351, 1559183351, 2),
238 (25, 'departments', '6', 'admin', 1559183371, 1559183371, 2),
239 (26, 'departments', '7', 'admin', 1559183383, 1559183383, 2),
240 (27, 'departments', '8', 'admin', 1559183393, 1559183393, 2),
241 (28, 'class_time_table', '5', 'admin', 1559183465, 1559183465, 2),
242 (29, 'exam_time_table', '3', 'admin', 1559183503, 1559183503, 2),
243 (30, 'exam_time_table', '4', 'admin', 1559183553, 1559183553, 2),
244 (31, 'exam_time_table', '5', 'admin', 1559183587, 1559183587, 2),
245 (32, 'departments', '9', 'admin', 1559183674, 1559183674, 2),
246 (33, 'schools', '5', 'admin', 1559183702, 1559183702, 2),
247 (34, 'exam_time_table', '6', 'koech', 1559184316, 1559184316, 4);
248
249 -- --------------------------------------------------------
250
251 --
252 -- Table structure for table `membership_users`
253 --
254
255 CREATE TABLE IF NOT EXISTS `membership_users` (
256 `memberID` varchar(20) NOT NULL,
257 `passMD5` varchar(40) DEFAULT NULL,
258 `email` varchar(100) DEFAULT NULL,
259 `signupDate` date DEFAULT NULL,
260 `groupID` int(10) unsigned DEFAULT NULL,
261 `isBanned` tinyint(4) DEFAULT NULL,
262 `isApproved` tinyint(4) DEFAULT NULL,
263 `custom1` text,
264 `custom2` text,
265 `custom3` text,
266 `custom4` text,
267 `comments` text,
268 `pass_reset_key` varchar(100) DEFAULT NULL,
269 `pass_reset_expiry` int(10) unsigned DEFAULT NULL
270 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
271
272 --
273 -- Dumping data for table `membership_users`
274 --
275
276 INSERT INTO `membership_users` (`memberID`, `passMD5`, `email`, `signupDate`, `groupID`, `isBanned`, `isApproved`, `custom1`, `custom2`, `custom3`, `custom4`, `comments`, `pass_reset_key`, `pass_reset_expiry`) VALUES
277 ('admin', '7488e331b8b64e5794da3fa4eb10ad5d', 'ronniengoda@gmail.com', '2018-12-04', 2, 0, 1, NULL, NULL, NULL, NULL, 'Admin member created automatically on 2018-12-04\nRecord updated automatically on 2018-12-04', NULL, NULL),
278 ('guest', '827ccb0eea8a706c4c34a16891f84e7b', NULL, '2018-12-04', 1, 0, 1, NULL, NULL, NULL, NULL, 'Anonymous member created automatically on 2018-12-04', NULL, NULL),
279 ('hello', '827ccb0eea8a706c4c34a16891f84e7b', 'hello@world.com', '2018-12-05', 3, 0, 1, 'Technology education', '', '', '', 'member signed up through the registration form.', NULL, NULL),
280 ('kenny', '827ccb0eea8a706c4c34a16891f84e7b', 'kenny@gmail.co', '2018-12-04', 3, 0, 1, 'Agtech', '', '', '', 'member signed up through the registration form.', NULL, NULL),
281 ('koech', '827ccb0eea8a706c4c34a16891f84e7b', 'charleskoech@gmail.com', '2018-12-04', 4, 0, 1, 'Technology education', '', '', '', 'Class rep TED 2ND years 2018', NULL, NULL),
282 ('ronnie', '827ccb0eea8a706c4c34a16891f84e7b', 'ronniengoda@gmail.com', '2018-12-04', 3, 0, 1, 'Technology education', '', '', '', 'member signed up through the registration form.', NULL, NULL),
283 ('sinhvien', '827ccb0eea8a706c4c34a16891f84e7b', 'omollo@nimetoka.bondo', '2018-12-05', 3, 0, 1, 'Og', '', '', '', 'member signed up through the registration form.', NULL, NULL);
284
285 -- --------------------------------------------------------
286
287 --
288 -- Table structure for table `ngành họcs`
289 --
290
291 CREATE TABLE IF NOT EXISTS `ngành họcs` (
292 `id` int(10) unsigned NOT NULL,
293 `name` varchar(40) NOT NULL,
294 `school` int(10) unsigned NOT NULL
295 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
296
297 -- --------------------------------------------------------
298
299 --
300 -- Table structure for table `notices`
301 --
302
303 CREATE TABLE IF NOT EXISTS `notices` (
304 `id` int(10) unsigned NOT NULL,
305 `notice` text NOT NULL,
306 `school` int(10) unsigned NOT NULL,
307 `department` int(10) unsigned NOT NULL,
308 `year_of_study` varchar(40) NOT NULL,
309 `date` date DEFAULT NULL
310 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
311
312 --
313 -- Dumping data for table `notices`
314 --
315
316 INSERT INTO `notices` (`id`, `notice`, `school`, `department`, `year_of_study`, `date`) VALUES
317 (1, 'Lớp tổ chức thăm bạn Chinh lằm viền ngày 20/10', 1, 1, '2', '2018-12-04'),
318 (2, 'Lịch lao động lớp kiểm thử phần mềm', 1, 1, '2', '2018-12-04'),
319 (3, 'Hiển thị thông tin lớp học ngày mai, mọi người đi đầy đủ nhé', 1, 1, '3', '2019-05-29');
320
321 -- --------------------------------------------------------
322
323 --
324 -- Table structure for table `personal_time_table`
325 --
326
327 CREATE TABLE IF NOT EXISTS `personal_time_table` (
328 `id` int(10) unsigned NOT NULL,
329 `day` varchar(40) NOT NULL,
330 `time_start` time NOT NULL,
331 `activity` varchar(40) NOT NULL,
332 `time_end` time NOT NULL
333 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
334
335 --
336 -- Dumping data for table `personal_time_table`
337 --
338
339 INSERT INTO `personal_time_table` (`id`, `day`, `time_start`, `activity`, `time_end`) VALUES
340 (1, 'Tuesday', '18:00:00', 'Học lý thuyết', '19:00:00'),
341 (2, 'Monday', '20:00:00', 'Làm bài tập lớn', '10:00:00');
342
343 -- --------------------------------------------------------
344
345 --
346 -- Table structure for table `schools`
347 --
348
349 CREATE TABLE IF NOT EXISTS `schools` (
350 `id` int(10) unsigned NOT NULL,
351 `name` varchar(40) NOT NULL
352 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
353
354 --
355 -- Dumping data for table `schools`
356 --
357
358 INSERT INTO `schools` (`id`, `name`) VALUES
359 (1, 'CNTT K45A'),
360 (2, 'Tin Học Văn Phòng'),
361 (3, 'CNTT K45B'),
362 (4, 'Tin Học 3A'),
363 (5, 'K01');
364
365 -- --------------------------------------------------------
366
367 --
368 -- Table structure for table `student_details`
369 --
370
371 CREATE TABLE IF NOT EXISTS `student_details` (
372 `id` int(10) unsigned NOT NULL,
373 `full_name` varchar(40) NOT NULL,
374 `school` int(10) unsigned NOT NULL,
375 `department` int(10) unsigned NOT NULL,
376 `year_of_study` varchar(40) NOT NULL,
377 `reg_no` varchar(40) NOT NULL
378 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
379
380 --
381 -- Dumping data for table `student_details`
382 --
383
384 INSERT INTO `student_details` (`id`, `full_name`, `school`, `department`, `year_of_study`, `reg_no`) VALUES
385 (1, 'Phạm Quang Sáng', 1, 1, '2', 'TED/118/19'),
386 (2, 'Cao Văn Bằng', 2, 2, '4', 'COM/111/19'),
387 (3, 'Trần Anh Thư', 1, 1, '2', 'TED/1234/19'),
388 (4, 'Lê Hương', 2, 2, '4', 'COM/134/19');
389
390 --
391 -- Indexes for dumped tables
392 --
393
394 --
395 -- Indexes for table `class_time_table`
396 --
397 ALTER TABLE `class_time_table`
398 ADD PRIMARY KEY (`id`), ADD KEY `school` (`school`), ADD KEY `department` (`department`);
399
400 --
401 -- Indexes for table `departments`
402 --
403 ALTER TABLE `departments`
404 ADD PRIMARY KEY (`id`), ADD KEY `school` (`school`);
405
406 --
407 -- Indexes for table `exam_time_table`
408 --
409 ALTER TABLE `exam_time_table`
410 ADD PRIMARY KEY (`id`), ADD KEY `school` (`school`), ADD KEY `department` (`department`);
411
412 --
413 -- Indexes for table `membership_grouppermissions`
414 --
415 ALTER TABLE `membership_grouppermissions`
416 ADD PRIMARY KEY (`permissionID`);
417
418 --
419 -- Indexes for table `membership_groups`
420 --
421 ALTER TABLE `membership_groups`
422 ADD PRIMARY KEY (`groupID`);
423
424 --
425 -- Indexes for table `membership_userpermissions`
426 --
427 ALTER TABLE `membership_userpermissions`
428 ADD PRIMARY KEY (`permissionID`);
429
430 --
431 -- Indexes for table `membership_userrecords`
432 --
433 ALTER TABLE `membership_userrecords`
434 ADD PRIMARY KEY (`recID`), ADD UNIQUE KEY `tableName_pkValue` (`tableName`,`pkValue`), ADD KEY `pkValue` (`pkValue`), ADD KEY `tableName` (`tableName`), ADD KEY `memberID` (`memberID`), ADD KEY `groupID` (`groupID`);
435
436 --
437 -- Indexes for table `membership_users`
438 --
439 ALTER TABLE `membership_users`
440 ADD PRIMARY KEY (`memberID`), ADD KEY `groupID` (`groupID`);
441
442 --
443 -- Indexes for table `ngành họcs`
444 --
445 ALTER TABLE `ngành họcs`
446 ADD PRIMARY KEY (`id`), ADD KEY `school` (`school`);
447
448 --
449 -- Indexes for table `notices`
450 --
451 ALTER TABLE `notices`
452 ADD PRIMARY KEY (`id`), ADD KEY `school` (`school`), ADD KEY `department` (`department`);
453
454 --
455 -- Indexes for table `personal_time_table`
456 --
457 ALTER TABLE `personal_time_table`
458 ADD PRIMARY KEY (`id`);
459
460 --
461 -- Indexes for table `schools`
462 --
463 ALTER TABLE `schools`
464 ADD PRIMARY KEY (`id`);
465
466 --
467 -- Indexes for table `student_details`
468 --
469 ALTER TABLE `student_details`
470 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `reg_no_unique` (`reg_no`), ADD KEY `school` (`school`), ADD KEY `department` (`department`);
471
472 --
473 -- AUTO_INCREMENT for dumped tables
474 --
475
476 --
477 -- AUTO_INCREMENT for table `class_time_table`
478 --
479 ALTER TABLE `class_time_table`
480 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
481 --
482 -- AUTO_INCREMENT for table `departments`
483 --
484 ALTER TABLE `departments`
485 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
486 --
487 -- AUTO_INCREMENT for table `exam_time_table`
488 --
489 ALTER TABLE `exam_time_table`
490 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
491 --
492 -- AUTO_INCREMENT for table `membership_grouppermissions`
493 --
494 ALTER TABLE `membership_grouppermissions`
495 MODIFY `permissionID` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
496 --
497 -- AUTO_INCREMENT for table `membership_groups`
498 --
499 ALTER TABLE `membership_groups`
500 MODIFY `groupID` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
501 --
502 -- AUTO_INCREMENT for table `membership_userpermissions`
503 --
504 ALTER TABLE `membership_userpermissions`
505 MODIFY `permissionID` int(10) unsigned NOT NULL AUTO_INCREMENT;
506 --
507 -- AUTO_INCREMENT for table `membership_userrecords`
508 --
509 ALTER TABLE `membership_userrecords`
510 MODIFY `recID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=35;
511 --
512 -- AUTO_INCREMENT for table `ngành họcs`
513 --
514 ALTER TABLE `ngành họcs`
515 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
516 --
517 -- AUTO_INCREMENT for table `notices`
518 --
519 ALTER TABLE `notices`
520 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
521 --
522 -- AUTO_INCREMENT for table `personal_time_table`
523 --
524 ALTER TABLE `personal_time_table`
525 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
526 --
527 -- AUTO_INCREMENT for table `schools`
528 --
529 ALTER TABLE `schools`
530 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
531 --
532 -- AUTO_INCREMENT for table `student_details`
533 --
534 ALTER TABLE `student_details`
535 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
536 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
537 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
538 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;